DROP TABLE Contract_history
CREATE TABLE [dbo].[Contract_history](
	[id_hist] [int] IDENTITY(1,1) NOT NULL,
	[date_create] [date] NOT NULL DEFAULT GETDATE(),
	[who_create] [nvarchar](250) NOT NULL DEFAULT SUSER_SNAME(),
	[ContractID] [int] NOT NULL,
	[ManagerID] [int] NOT NULL,
	[ClientID] [int] NOT NULL,
	[Date] [date] NOT NULL,
	[Number] [nvarchar](250) NOT NULL,
	[ContractTypeID] [int] NOT NULL,
	[ContractStateID] [int] NOT NULL,
	[Cost] [int] NOT NULL,
	CONSTRAINT [PK_Contract_history] PRIMARY KEY CLUSTERED ([id_hist])
)

DROP TABLE Contract_histori
CREATE TABLE [dbo].[Contract_histori](
	[id_hist] [int] IDENTITY(1,1) NOT NULL,
	[date_create] [date] NOT NULL DEFAULT GETDATE(),
	[who_create] [nvarchar](250) NOT NULL DEFAULT SUSER_SNAME(),
	[ContractID] [int] NOT NULL,
	[ManagerID] [int] NOT NULL,
	[ClientID] [int] NOT NULL,
	[Date] [date] NOT NULL,
	[Number] [nvarchar](250) NOT NULL,
	[ContractTypeID] [int] NOT NULL,
	[ContractStateID] [int] NOT NULL,
	[Cost] [int] NOT NULL,
	CONSTRAINT [PK_Contract_histori] PRIMARY KEY CLUSTERED ([id_hist])
)